<%@page import="com.bill.common.utils.TranType"%>
<%@page import="com.bill.common.system.dto.SingleGroupReportStatDTO"%>
<%@page import="java.util.List"%>
<%@page import="com.sinba.common.dto.PageDTO"%>
<%@page import="com.bill.common.system.dto.TransactionRecordDTO"%>
<%@page import="com.bill.common.system.service.ITransactionRecordService"%>
<%@page import="com.bill.common.user.dto.AccountDTO"%>
<%@page import="com.bill.common.user.service.IAccountService"%>
<%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>
<%@page import="org.springframework.context.ApplicationContext"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ include file="../language.jsp" %>

<%
if(session.getAttribute("password2")==null){
	response.sendRedirect( "login2.jsp?pageUrl=user/st2aticAccountDetails.jsp");
	return;
}


ApplicationContext ac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
ITransactionRecordService transactionRecordService = (ITransactionRecordService)ac.getBean("transactionRecordService");
TransactionRecordDTO trDTO = new TransactionRecordDTO();
trDTO.setLoginName((String)session.getAttribute("loginName"));
int pages = 1;
String sidx = "recordId";
String sord="desc";
if(request.getParameter("pages")!=null && request.getParameter("_pages")!=""){
	pages = Integer.parseInt(request.getParameter("pages"));
}
int rows = 10;
int start = ( pages - 1 ) * rows;
trDTO.setStart( start );
trDTO.setLimit( rows );
trDTO.setSearchType("Static");
Object param1 = request.getParameter("trDTO.transactionType");

if(param1!=null 
&& param1!="" 
&& !"null".equals(param1)){
	trDTO.setTransactionType(request.getParameter("trDTO.transactionType"));
	pages=1;
}
trDTO.setDtype("Static");
PageDTO pageDTO = transactionRecordService.findTransactionRecordPager(trDTO, sord, sidx);
if(pageDTO!=null){
	pageDTO.setPage( pages );
	pageDTO.setRows( rows );
}
request.setAttribute("pageDTO",pageDTO);

//统计：
Double income = 0D;
TransactionRecordDTO trDto1 = new TransactionRecordDTO();
trDto1.setInOrExp("income");
trDto1.setDtype("Static");
trDto1.setLoginName((String)session.getAttribute("loginName"));
List<SingleGroupReportStatDTO> sgrs = transactionRecordService.statAccount(trDto1);
for(SingleGroupReportStatDTO sgr : sgrs){
	if(sgr.getAggField()!=null){
		income = income+sgr.getAggField();
	}
}
request.setAttribute("income",income);


Double expenditure = 0D;
TransactionRecordDTO trDto2 = new TransactionRecordDTO();
trDto2.setInOrExp("expenditure");
trDto2.setDtype("Static");
trDto2.setTransactionTypes(TranType.SubAccount);
trDto2.setLoginName((String)session.getAttribute("loginName"));
List<SingleGroupReportStatDTO> sgrs2 = transactionRecordService.statAccount(trDto2);
for(SingleGroupReportStatDTO sgr : sgrs2){
	if(sgr.getAggField()!=null){
		expenditure = expenditure+sgr.getAggField();
	}
}
request.setAttribute("expenditure",expenditure);
request.setAttribute("transactionTypes",TranType.SubAccount);


%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>

<meta charset="UTF-8">
<title><fmt:message key="i18n.jtMoneyDetail"/>-<fmt:message key="i18n.title"/></title>
<meta name="apple-mobile-web-app-capable" content="yes" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1" />
<link rel="stylesheet" type="text/css" href="css/style1.css">
<script type="text/javascript" src="../scripts/jquery-1.11.0.min.js"></script>
<script type="text/javascript" src="../scripts/script.js"></script>
<body>
<div class="account">
	<div class="top2" style="background:#ffffed;">
	<a class="top2L" ><fmt:message key="i18n.moneyManage"/> &gt; 股票钱包历史</a>
	<div class="top2R">&nbsp;</div>
	</div>
	<div class="cont" style="padding: 0;">
         <div class="tx_Top" >
			<p><fmt:message key="i18n.balance"/>：<fmt:formatNumber value="${income - expenditure}" pattern="#0.0000"/>
         </div>
    	 <div class="tx_Top" align="left" style="padding: 0 20px 11px 20px;">
    	
    		<form id="bonusSeachForm" action="dynamicAward.jsp" method="post">
				<input name="sidx" value="recordId" type="hidden" >
				<input name="sord" value="desc" type="hidden" >
				<input name="trDTO.searchType" value="bonus" type="hidden" >
				<input name="trDTO.loginName" value="${session.loginName }" type="hidden" >
				<table width="100%">
							<tr>
							 	<td>
							 		<fmt:message key="i18n.type"/> <select name="trDTO.transactionType" class="tx_contBoxR2_1">
							 	   	<option value="">--<fmt:message key="i18n.pelaseSelect"/>--</option>
							 	   	<c:forEach items="${transactionTypes}" var="tts">
							 	   		<option value="${tts}"><fmt:message key="${tts}" /></option>
							 	   	</c:forEach>
							 	   </select>
							 		<fmt:message key="i18n.jiesuanData"/> <input name="trDTO.startTime" class="easyui-datebox tx_contBoxR4"></input> <fmt:message key="i18n.to"/>  <input name="trDTO.endTime" class="easyui-datebox tx_contBoxR4"/> 
							 		<a style="cursor: pointer;" id="doSeach"><input type="button" class="ctrR1BoxAn2" value="<fmt:message key="i18n.serach"/>" /></a>
							 	</td>
							</tr>
				</table>
				</form>
			</div>
			<div>	
    		<table style="margin-top: 0px;" class="txList" width="100%" cellspacing="0" cellpadding="0">
				<thead>
					<tr>
						<th><fmt:message key="i18n.type"/></th>
						<th><fmt:message key="i18n.jiaoyiUser"/></th>
						<th><fmt:message key="i18n.income"/></th>
						<th><fmt:message key="i18n.zhichu"/></th>
						<th><fmt:message key="i18n.balance"/></th>
						<th><fmt:message key="i18n.operationTime"/></th>
						<th><fmt:message key="i18n.remark"/></th>
					</tr>
					
				</thead>
				<tbody>
					<c:forEach items="${pageDTO.data}" var="data">
						<tr>
							<td><fmt:message key="${data.transactionType}" /></td>
							<td>${data.transactionObject}</td>
							<td><fmt:formatNumber value="${data.income}" pattern="#0.0000"/></td>
							<td><fmt:formatNumber value="${data.expenditure}" pattern="#0.0000"/></td>
							<td><fmt:formatNumber value="${data.balance}" pattern="#0.0000"/></td>
							<td><fmt:formatDate value="${data.optDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
							<td>${data.remark}</td>
						</tr>
					</c:forEach>
					<c:if test="${empty pageDTO.data}">
						<tr>
							<td colspan="7" align="center"><fmt:message key="i18n.noData"/>!</td>
						</tr>
					</c:if>
				</tbody>		        		
			</table>
			</div>
			<!-- 分页 start -->
			<div class="pageBox" style="margin-top: 40px;">
				<div id="tr_recommendGrid_pager" class="page">
					<a style="color: blue;" href="st2aticAccountDetails.jsp?pages=1"><fmt:message key="i18n.firstPage"/></a>
					<c:if test="${pageDTO.page>1}">
						<a style="color: blue;" href="st2aticAccountDetails.jsp?pages=${pageDTO.page-1}"><fmt:message key="i18n.upPage"/></a>
					</c:if>
					<a>${pageDTO.page}/${pageDTO.total}</a>
					<c:if test="${pageDTO.page+1<=pageDTO.total}">
						<li><a style="color: blue;" href="st2aticAccountDetails.jsp?pages=${pageDTO.page+1}"><fmt:message key="i18n.nextPage"/></a>
					</c:if>
					<a style="color: blue;" href="st2aticAccountDetails.jsp?pages=${pageDTO.total}"><fmt:message key="i18n.endPage"/></a>
					<a><fmt:message key="i18n.total"/>${pageDTO.totalSize}<fmt:message key="i18n.tiao"/></a>
				</div>
			</div>
			<!-- 分页 end  -->

    	</div>
    	
</div>
<script>

$(function(){
	//showTransRecord('tr_recommend_table','tr_recommend_pager','recommend',1,10,'optDate','desc');
	//showDirectPushUser('tr_recommendGrid_table','tr_recommendGrid_pager','${user.loginName}',1,10,'registerTime','desc');
    $("#doSeach").click(function(){
    	$("#bonusSeachForm").submit();
    });
})

</script>

</body>
</html>